Introduction

Recommendation systems are a relatively new occurrence that have become a necessity when using modern day media platforms. One of the most famous examples of this is movie recommendations, present on a variety of video streaming services such as Netflix, Hulu and HBO. As students interested in data science and the applications thereof, as well as being avid consumers of movies ourselves, we would like to see how we could develop our own movie recommendation program. Prior to writing all the scripts/functions, we have cleaned and merged the raw data sets. The most recent versions are named movies_ratings_platforms.csv and movies_ratings_platforms_top1000.csv.

Summary Information Script

## $n_col
## [1] 24
## 
## $col_names
##  [1] "Movie"                     "Netflix"                  
##  [3] "Hulu"                      "Prime.Video"              
##  [5] "Disney."                   "imdb_title_id"            
##  [7] "date_published"            "genre"                    
##  [9] "duration"                  "description"              
## [11] "weighted_average_vote"     "total_votes"              
## [13] "mean_vote"                 "allgenders_0age_avg_vote" 
## [15] "allgenders_0age_votes"     "allgenders_18age_avg_vote"
## [17] "allgenders_18age_votes"    "allgenders_30age_avg_vote"
## [19] "allgenders_30age_votes"    "allgenders_45age_avg_vote"
## [21] "allgenders_45age_votes"    "Certificate"              
## [23] "Genre"                     "Meta_score"               
## 
## $n_rows
## [1] 207
## 
## $n_movies
## [1] 169
## 
## $mean_imdb
## [1] 7.565217
## 
## $highest_imdb
## [1] 9
## 
## $lowest_imdb
## [1] 2.4
## 
## $mean_meta
## [1] 78.32367
## 
## $top_4_certificates
##   Certificate  n
## 1           U 72
## 2           A 38
## 3          UA 34
## 4           R 24

We created a summary information function to compute useful information about our movie platform data sets. When run on our cleaned version; movies_ratings_platforms_top1000.csv data set, we find that the data set has 24 total columns, the titles of each being: Movie, Netflix, Hulu, Prime.Video, Disney., imdb_title_id, date_published, genre, duration, description, weighted_average_vote, total_votes, mean_vote, allgenders_0age_avg_vote, allgenders_0age_votes, allgenders_18age_avg_vote, allgenders_18age_votes, allgenders_30age_avg_vote, allgenders_30age_votes, allgenders_45age_avg_vote, allgenders_45age_votes, Certificate, Genre, Meta_score. The main columns we will use for analysis are weighted_average_vote and Meta_score. The average value for IMdb rating and meta score are 7.5652174 and 78.3236715, respectively. For 7.5652174, this is from a range of 9 (high) to 2.4 (low). The data set also consists of 207 movies, but as some movies are repeats, there are only actually 169 movies. Of the available movies, the most certificates are U, A, UA, R from most to least.

Aggregate Table Script

Movie Genre weighted_average_vote Metascore duration Netflix Hulu Prime.Video Disney.
The Dark Knight Action, Crime, Drama 9.0 84 152 No Yes No No
Inception Action, Adventure, Sci-Fi 8.8 74 148 Yes No No No
The Matrix Action, Sci-Fi 8.7 73 136 Yes No No No
It’s a Wonderful Life Drama, Family, Fantasy 8.6 89 130 No No Yes No
The Green Mile Crime, Drama, Fantasy 8.6 61 189 No Yes No No
Back to the Future Adventure, Comedy, Sci-Fi 8.5 87 116 Yes No No No
Joker Crime, Drama, Thriller 8.5 59 122 Yes No No No
Psycho Horror, Mystery, Thriller 8.5 97 109 Yes No No No
The Lion King Animation, Adventure, Drama 8.5 88 88 No No No Yes
The Pianist Biography, Drama, Music 8.5 85 150 Yes No Yes No
3 Idiots Comedy, Drama 8.4 67 170 Yes No Yes No
Avengers: Endgame Action, Adventure, Drama 8.4 78 181 No No No Yes
Avengers: Infinity War Action, Adventure, Sci-Fi 8.4 68 149 Yes No No No
Django Unchained Drama, Western 8.4 81 165 Yes No No No
Raiders of the Lost Ark Action, Adventure 8.4 85 115 Yes No No No
Spider-Man: Into the Spider-Verse Animation, Action, Adventure 8.4 87 117 Yes No No No
WALL·E Animation, Adventure, Family 8.4 95 98 No No No Yes
Good Will Hunting Drama, Romance 8.3 70 126 No Yes No No
Inglourious Basterds Adventure, Drama, War 8.3 69 153 Yes No No No
Taxi Driver Crime, Drama 8.3 94 114 Yes No No No
Toy Story Animation, Adventure, Comedy 8.3 95 81 No No No Yes
Toy Story 3 Animation, Adventure, Comedy 8.3 92 103 No No No Yes
Batman Begins Action, Adventure 8.2 70 140 No Yes No No
Chak De! India Drama, Family, Sport 8.2 68 153 No No Yes No
Indiana Jones and the Last Crusade Action, Adventure 8.2 65 127 Yes No No No
Klaus Animation, Adventure, Comedy 8.2 65 96 Yes No No No
Monty Python and the Holy Grail Adventure, Comedy, Fantasy 8.2 91 91 Yes No No No
There Will Be Blood Drama 8.2 93 158 Yes No No No
Up Animation, Adventure, Comedy 8.2 88 96 No No No Yes
Finding Nemo Animation, Adventure, Comedy 8.1 90 100 No No No Yes
Inherit the Wind Biography, Drama, History 8.1 75 128 No No Yes No
Inside Out Animation, Adventure, Comedy 8.1 94 95 No Yes Yes Yes
Kill Bill: Vol. 1 Action, Crime, Thriller 8.1 69 111 No Yes No No
Lagaan: Once Upon a Time in India Adventure, Drama, Musical 8.1 84 224 Yes No No No
Life of Brian Comedy 8.1 77 94 Yes No No No
Room Drama, Thriller 8.1 86 118 Yes No No No
Song of the Sea Animation, Adventure, Drama 8.1 85 93 Yes No No No
Sweet Smell of Success Drama, Film-Noir 8.1 100 96 No No Yes No
The Man Who Shot Liberty Valance Drama, Western 8.1 94 123 No No Yes No
The Princess Bride Adventure, Family, Fantasy 8.1 77 98 No No No Yes
What Ever Happened to Baby Jane? Drama, Horror, Thriller 8.1 75 134 No No Yes No
Aladdin Animation, Adventure, Comedy 8.0 86 90 No No No Yes
Brief Encounter Drama, Romance 8.0 92 86 No No Yes No
Dallas Buyers Club Biography, Drama 8.0 80 117 Yes No No No
Fiddler on the Roof Drama, Family, Musical 8.0 67 181 No No Yes No
Groundhog Day Comedy, Fantasy, Romance 8.0 72 101 Yes No No No
Guardians of the Galaxy Action, Adventure, Comedy 8.0 76 121 No No No Yes
Her Drama, Romance, Sci-Fi 8.0 90 126 Yes No No No
Kill Bill: Vol. 2 Action, Crime, Thriller 8.0 83 137 No Yes No No
Magnolia Drama 8.0 77 188 Yes No No No
Marriage Story Comedy, Drama, Romance 8.0 94 137 Yes No No No
Monsters, Inc. Animation, Adventure, Comedy 8.0 79 92 No No No Yes
Papillon Biography, Crime, Drama 8.0 58 151 No No Yes No
Pirates of the Caribbean: The Curse of the Black Pearl Action, Adventure, Fantasy 8.0 63 143 No No No Yes
Ratatouille Animation, Adventure, Comedy 8.0 96 111 No No No Yes
Roman Holiday Comedy, Romance 8.0 78 118 No No Yes No
Rosemary’s Baby Drama, Horror 8.0 96 137 No No Yes No
Short Term 12 Drama 8.0 82 96 No No Yes No
Sin City Crime, Thriller 8.0 74 124 Yes No No No
Stalag 17 Comedy, Drama, War 8.0 84 120 No No Yes No
The Avengers Action, Adventure, Sci-Fi 8.0 69 143 No No Yes Yes
The Graduate Comedy, Drama, Romance 8.0 83 106 No Yes No No
The Incredibles Animation, Action, Adventure 8.0 90 115 No No No Yes
The King’s Speech Biography, Drama, History 8.0 88 118 Yes No No No
The Nightmare Before Christmas Animation, Family, Fantasy 8.0 82 76 No No No Yes
The Perks of Being a Wallflower Drama, Romance 8.0 67 103 Yes No No No
The Pursuit of Happyness Biography, Drama 8.0 64 117 Yes No No No
The Sound of Music Biography, Drama, Family 8.0 63 172 No No No Yes
The Straight Story Biography, Drama 8.0 86 112 No No No Yes
Togo Adventure, Biography, Drama 8.0 69 113 No No No Yes
Zootopia Animation, Adventure, Comedy 8.0 78 108 No No No Yes
Captain Fantastic Comedy, Drama 7.9 72 118 No Yes No No
Charade Comedy, Mystery, Romance 7.9 83 113 No No Yes No
District 9 Action, Sci-Fi, Thriller 7.9 81 112 Yes No No No
Dunkirk Action, Drama, History 7.9 94 106 No No Yes No
Harold and Maude Comedy, Drama, Romance 7.9 62 91 No No Yes No
Hunt for the Wilderpeople Adventure, Comedy, Drama 7.9 81 101 No Yes No No
In the Heat of the Night Crime, Drama, Mystery 7.9 75 110 No No Yes No
Isle of Dogs Animation, Adventure, Comedy 7.9 82 101 No No Yes No
Moon Drama, Mystery, Sci-Fi 7.9 67 97 Yes No No No
Mystic River Crime, Drama, Mystery 7.9 84 138 Yes No No No
Night of the Living Dead Horror, Thriller 7.9 89 96 No No Yes No
The Artist Comedy, Drama, Romance 7.9 89 100 Yes No No No
The Irishman Biography, Crime, Drama 7.9 94 209 Yes No No No
Thor: Ragnarok Action, Adventure, Comedy 7.9 74 130 No No No Yes
Toy Story 2 Animation, Adventure, Comedy 7.9 88 92 No No No Yes
About Time Comedy, Drama, Fantasy 7.8 55 123 Yes No No No
Apocalypto Action, Adventure, Drama 7.8 68 139 No No Yes No
Avatar Action, Adventure, Fantasy 7.8 83 162 No No No Yes
Back to the Future Part II Adventure, Comedy, Sci-Fi 7.8 57 108 Yes No No No
Big Hero 6 Animation, Action, Adventure 7.8 74 102 No No No Yes
Captain America: Civil War Action, Adventure, Sci-Fi 7.8 75 147 No No No Yes
Fantasia Animation, Family, Fantasy 7.8 96 125 No No No Yes
Ferris Bueller’s Day Off Comedy 7.8 61 103 Yes No No No
Loving Vincent Animation, Biography, Crime 7.8 62 94 No Yes No No
Manchester by the Sea Drama 7.8 96 137 No No Yes No
Mary Poppins Comedy, Family, Fantasy 7.8 88 139 No No No Yes
Misery Drama, Thriller 7.8 75 107 No Yes No No
Mississippi Burning Crime, Drama, History 7.8 65 128 No No Yes No
Remember the Titans Biography, Drama, Sport 7.8 48 113 No No No Yes
The Boondock Saints Action, Crime, Thriller 7.8 44 108 No No Yes No
The Boy in the Striped Pyjamas Drama, War 7.8 55 94 Yes No No No
The Conversation Drama, Mystery, Thriller 7.8 85 113 No No Yes No
The Count of Monte Cristo Action, Adventure, Drama 7.8 61 131 No No Yes No
The Curious Case of Benjamin Button Drama, Fantasy, Romance 7.8 70 166 Yes No No No
The Fighter Biography, Drama, Sport 7.8 79 116 No No Yes No
The Girl with the Dragon Tattoo Crime, Drama, Mystery 7.8 71 158 No No Yes No
The Hateful Eight Crime, Drama, Mystery 7.8 68 168 Yes No No No
The Lady Vanishes Mystery, Thriller 7.8 98 96 No No Yes No
Toy Story 4 Animation, Adventure, Comedy 7.8 84 100 No No No Yes
Veer-Zaara Drama, Family, Musical 7.8 67 192 No No Yes No
What’s Eating Gilbert Grape Drama 7.8 73 118 Yes No Yes No
Willy Wonka & the Chocolate Factory Family, Fantasy, Musical 7.8 67 100 Yes No No No
Airplane! Comedy 7.7 78 88 No No Yes No
As Good as It Gets Comedy, Drama, Romance 7.7 67 139 Yes No No No
Beasts of No Nation Drama, War 7.7 79 137 Yes No No No
Blazing Saddles Comedy, Western 7.7 73 93 No Yes No No
Captain America: The Winter Soldier Action, Adventure, Sci-Fi 7.7 70 136 No No No Yes
Ex Machina Drama, Sci-Fi, Thriller 7.7 78 108 Yes No No No
Mission: Impossible - Fallout Action, Adventure, Thriller 7.7 86 147 No Yes Yes No
Ordinary People Drama 7.7 86 124 No No Yes No
Philadelphia Drama 7.7 66 125 Yes No No No
Road to Perdition Crime, Drama, Thriller 7.7 72 117 Yes No No No
Roma Drama 7.7 96 135 Yes No No No
Sabrina Comedy, Drama, Romance 7.7 72 113 Yes No No No
Shine Biography, Drama, Music 7.7 87 105 No No Yes No
Silver Linings Playbook Comedy, Drama, Romance 7.7 81 122 Yes No No No
Star Trek II: The Wrath of Khan Action, Adventure, Sci-Fi 7.7 67 113 No Yes Yes No
Tangled Animation, Adventure, Comedy 7.7 71 100 No No No Yes
The African Queen Adventure, Drama, Romance 7.7 91 105 No No Yes No
The Last of the Mohicans Action, Adventure, Drama 7.7 76 112 No No Yes No
The Last Samurai Action, Drama, War 7.7 55 154 Yes No No No
The Machinist Drama, Thriller 7.7 61 101 No No Yes No
The Muppet Christmas Carol Comedy, Drama, Family 7.7 64 85 No No No Yes
The Social Network Biography, Drama 7.7 95 120 Yes No No No
The Theory of Everything Biography, Drama, Romance 7.7 72 123 Yes No No No
Who Framed Roger Rabbit Animation, Adventure, Comedy 7.7 83 104 No No No Yes
Wreck-It Ralph Animation, Adventure, Comedy 7.7 72 101 No No No Yes
50/50 Comedy, Drama, Romance 7.6 72 100 No Yes No No
Blow Biography, Crime, Drama 7.6 52 124 Yes No No No
Despicable Me Animation, Comedy, Family 7.6 72 95 Yes No No No
End of Watch Action, Crime, Drama 7.6 68 109 Yes No No No
Escape from Alcatraz Action, Biography, Crime 7.6 76 112 No Yes Yes No
Giant Drama, Western 7.6 84 201 Yes No Yes No
Guardians of the Galaxy Vol. 2 Action, Adventure, Comedy 7.6 67 136 No No No Yes
Hell or High Water Action, Crime, Drama 7.6 88 102 Yes No No No
Incredibles 2 Animation, Action, Adventure 7.6 80 118 Yes No No No
Minority Report Action, Crime, Mystery 7.6 80 145 Yes No No No
Moana Animation, Adventure, Comedy 7.6 81 107 No No No Yes
Mulan Animation, Adventure, Family 7.6 71 88 No No No Yes
Sicario Action, Crime, Drama 7.6 82 121 No No Yes No
The Florida Project Drama 7.6 92 111 Yes No No No
The Jungle Book Animation, Adventure, Family 7.6 65 78 No No No Yes
The Little Mermaid Animation, Family, Fantasy 7.6 88 83 Yes No No Yes
The Long Goodbye Comedy, Crime, Drama 7.6 87 112 No No Yes No
The Muppet Movie Adventure, Comedy, Family 7.6 74 95 No No No Yes
The Naked Gun: From the Files of Police Squad! Comedy, Crime 7.6 76 85 Yes No No No
Zombieland Adventure, Comedy, Fantasy 7.6 73 88 No Yes Yes No
True Grit Adventure, Drama, Western 7.4 80 128 No Yes Yes No
Freaks Drama, Mystery, Sci-Fi 6.7 80 105 Yes No No No
Some Like It Hot Comedy, Musical, Romance 6.7 98 65 No No Yes No
Miracle on 34th Street Family, Fantasy 6.5 88 114 No No No Yes
A Star Is Born Drama, Music, Romance 6.2 88 139 No No Yes No
Dark Waters Drama, Horror, Mystery 6.1 73 94 No No Yes No
Pride Drama, Sport 6.1 79 104 No No Yes No
Naked Comedy, Fantasy, Romance 5.4 84 96 Yes No No No
Serenity Drama, Mystery, Thriller 5.4 74 106 No No Yes No
Coco Comedy, Drama 3.3 81 95 No No No Yes
Drive Action, Crime, Thriller 3.0 78 147 Yes No Yes No

This table summarizes the information of each movie, such as the movie name, the genre, weighted average vote, metascore, duration, and whether the movie is on each platform(Netflix, Hulu, Prime Video, and Disney).

Chart Script (1) - Pie Chart

This pie chart shows the popularity of each genre based on the movies that are rated above 7.0. The result shows that among those movies that are rated 7.0 or higher, 43.3% are Drama, 24.9% are Comedy, 16.9% are Action, 13.4% are Romance, and 1.5% are Horror. The genre Drama is the most popular and Horror is the least popular among high-rated movies.

The numbers around the pie chart represent the number of movies in each genre.

Chart Script (2) - Bar Chart

This bar chart is used to express binary variables. In other words, to show whether a movie is “on” or “not on” a certain platform. Bar chart is good for this intention, because it allows users to quickly spot the difference in value. Below is an example bar char that checks on the movie A Christmas Prince.

The bar chart shows the platforms: Netflix, Disney., Hulu, Prime.Video and illustrate whether a certain movie is on or not on those platform.

Chart Script (3) - Scatter Plot

This plot chart attempts to express the most popular movies available on every streaming platform. This expresses the types of streaming service data that we have access to, and demonstrates the capability of sorting the overall data frame for specific values as well as combining them afterwords. Scatter plots were used for this display because of the many data points specific numerical values, and multiple categories (platforms).

The scatter plot displays the top 5 movies from every streaming service. The points contain the name and rating of the movie (when hovered), and are color coded by streaming service. The y values are the movie ratings.